CREATE TABLE NewSalesRegions
(
	RegionID INT IDENTITY(1,1)
	, RegionCode VARCHAR(20) NOT NULL
)

INSERT NewSalesRegions VALUES ('NORTH')
INSERT NewSalesRegions VALUES ('NORTHEAST')
INSERT NewSalesRegions VALUES ('NORTHWEST')
INSERT NewSalesRegions VALUES ('SOUTHEAST')
INSERT NewSalesRegions VALUES ('SOUTHWEST')
INSERT NewSalesRegions VALUES ('SOUTH')
INSERT NewSalesRegions VALUES ('EAST')
INSERT NewSalesRegions VALUES ('WEST')
INSERT NewSalesRegions VALUES ('CENTRAL')